If you can't see your calls, you can't fix your phones. A call log template for your small business turns a fuzzy hunch ("we're probably missing some calls") into a hard number you can act on. Below is the exact spreadsheet — the columns that matter, the ones to skip, and three pivot-table views that tell you where your money is leaking.
You can build this in Google Sheets or Excel in ten minutes. One row per call. Fill it in for 30 days and you'll know more about your shop than most owners learn in a year.
Resist the urge to track everything. More columns mean fewer get filled in. These eight carry their weight:
| Column | What goes in it | Why it matters |
|---|---|---|
| Date/Time | When the call came in | Reveals your true miss windows |
| Source | LSA, GBP, referral, truck, repeat, web | Tells you which marketing actually rings the phone |
| Caller | Name + phone | So you can call back and match repeats |
| Issue | Spring, opener, off-track, new door, quote | Shows your real job mix |
| Answered? | Yes / Voicemail / Missed | The single most important field |
| Outcome | Booked / Quoted / Callback / Lost | Turns activity into results |
| Revenue | $ if booked (est. or final) | Ties calls to dollars |
| Follow-up date | When to chase an unbooked quote | Stops leads from going cold |
Skip vanity columns like call duration or "customer mood." They feel useful and never get logged. If a field doesn't change a decision, cut it.
A call log only works if it's complete and consistent. Two rules do the heavy lifting.
Rule 1: Log every call, including the ones you miss. A voicemail you never returned is still a call — arguably the most important one, because it's lost revenue. If you only log booked jobs, your log will tell you everything is fine while your bank account disagrees.
Rule 2: Use a fixed list for Source and Outcome. Free-typed entries turn into a mess ("google," "Google," "GBP," "google biz") that no pivot table can count. Set a dropdown with fixed choices and stick to it. This is the difference between data and a diary.
Once you have 30 days of rows, three pivot tables do the analysis for you.
View 1 — Miss rate by hour. Rows = hour of day, Values = count of Missed/Voicemail. This shows your true danger windows. Most shops find a spike after 5 PM and on weekends — exactly when a homeowner with a car trapped in the garage is calling. If your misses cluster after hours, that's not a staffing problem you can cheaply fix by hand. It's the case for 24/7 coverage.
View 2 — Booked revenue by source. Rows = Source, Values = sum of Revenue where Outcome = Booked. This is the report that ends marketing arguments. You'll often find one channel quietly outpulling the others three to one — and another you're paying for that books almost nothing.
View 3 — Open follow-ups. Filter = Outcome is Quoted or Callback AND Follow-up date is on or before today. This is your daily call-back list. Clear it before noon and you'll book quotes your competitors let go cold.
Say your 30-day log shows 220 calls. Of those, 38 hit voicemail or were missed, mostly after 5 PM and on Saturdays. Your booked calls averaged a $340 ticket, and your booking rate on answered calls was 45%.
Apply that same 45% to the 38 you missed: roughly 17 jobs you never got a shot at. At $340 each, that's about $5,780 in a single month sitting in your voicemail box. Run it for your own shop — even if your miss count is half that, the number tends to be bigger than owners expect.
That's the whole point of the log: it converts "we're probably fine" into a dollar figure you can decide to fix.
A call log is the foundation for two other tools. To turn the raw hourly-miss data into a coverage plan, run the numbers through the peak-hour call analysis worksheet. To make the review a habit instead of a one-off, roll the monthly totals into the monthly missed-revenue audit template.
And the bigger lesson: manual logging tells you where the leak is, but it can't plug it. If your log keeps showing after-hours misses, the fix is coverage that never sleeps. That's the case for building the log into a wider garage door business automation plan, where the phone answers, captures, and logs itself.
Here's the shortcut most owners land on: when Ava answers every call, she logs it for you — name, phone, address, issue, and outcome land in a summary the moment the call ends. The spreadsheet becomes a report you read, not a chore you dread. Start with the manual log to see the problem clearly. Then decide whether you want to keep filling rows by hand.
Call the live demo and have Ava call you now — hear exactly what your customers will hear when they call your shop.